-- Create table
create table jms_dwd.dwd_YL_OMS_ORDER_RETURN_dt
(
   ID                          bigint             comment  '货品名称'
  ,WAYBILL_ID                 string             comment  '三段码'
  ,TERMINAL_DISPATCH_CODE     string              comment  '收件邮编'
  ,NEW_TERMINAL_DISPATCH_CODE string              comment  '收件人邮箱'
  ,DISPATCH_NETWORK_CODE      string             comment  '是否保价'
  ,DISPATCH_NETWORK_NAME      string             comment  '货品声明价值'
  ,LAST_CENTER_CODE           string             comment  '保费'
  ,LAST_CENTER_NAME           string             comment  '货品类型ID'
  ,INPUT_TIME                 date               comment  '货品类型编码'
  ,CREATE_TIME                date               comment  '货品类型名称'
  ,UPDATE_TIME                 string             comment '更新时间'
)
COMMENT '转寄件原单信息'
PARTITIONED BY (
  `dt` string COMMENT '分区(yyyy-mm-dd)-inputtime')
STORED AS PARQUET
LOCATION
  '/dw/hive/jms_dwd.db/external/dwd_YL_OMS_ORDER_RETURN_dt';
